import logging
from sqlalchemy import Result, select, text
from sqlalchemy.ext.asyncio import AsyncSession

main_logger = logging.getLogger("main")
logger = main_logger.getChild("guides")


async def get_types(session: AsyncSession) -> list:

    stmt = text("SELECT * FROM section_types")
    result: Result = await session.execute(stmt)

    return list(result)
